Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SupplierID (FK)(PK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | SupplierItemCatalogBaseCost(AS_CST_SPR_ITM_BS) |
SupplierID (FK)(PK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | Deal(CO_DL) |
DealCode (FK)(PK) | A code which uniquely identifies the type of DEAL offered by the SUPPLIER. For example the SUPPLIER may offer an additional 2% discount off the cost price, or increase the case units by 10% for the same cost price. Normally DEALs last for finite periods. | LU_DL | Code6 | char(6) | Deal(CO_DL) |
SupplierItemCostPerUnitTypeCode (FK)(PK) | Defines the unit type the owned attribute costs are assigned to for this item. Valid unit types include: SALE UNIT, PACK UNIT and SHIP UNIT. A single SUPPLIER ITEM may in effect have 1 to three SUPPLIER ITEM BASE COST entities associated with it. | TY_UN_CST | Code2 | char(2) | SupplierItemCatalogBaseCost(AS_CST_SPR_ITM_BS) |
SupplierItemID (FK)(PK) | The code assigned by the supplier to uniquely identify the ITEM | ID_ITM_SPR | Identity | integer | SupplierItemCatalogBaseCost(AS_CST_SPR_ITM_BS) |
CostChangeAmount | The difference between the standard and DEAL cost prices or the DEAL cost intended to replace the standard catalog cost for the item. | MO_CHN_CST | MoneyShortCost | decimal(16,5) | |
CostChangePercent | The percentage difference between the standard and DEAL cost prices or the DEAL cost intended to replace the standard catalog cost for the item. | PE_CHN_CST | Percent | decimal(7,4) | |
CostChangeReplaceOrModifyCode | A code that determines how the deal-supplier-cost-change-amount is to be applied -- i.e. it is to replace or modify the catalog cost. | LU_CHN_CST_RPL_MDF | Code2 | char(2) | |